package com.jeeplus.test.jlnu.xlsxManage.mapper;

import com.jeeplus.test.jlnu.xlsxManage.domain.entity.JlnuXlsxManage;
import com.jeeplus.test.jlnu.xlsxManage.domain.query.XlsxManagePageQuery;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 动态表头(JlnuXlsxManage)表数据库访问层
 *
 * @author ChiHongYu
 * @since 2025-02-17 15:16:35
 */
@Mapper
public interface JlnuXlsxManageMapper {


    JlnuXlsxManage queryById(Integer id);

    JlnuXlsxManage queryByType(String type,String officeId);


    JlnuXlsxManage getByOffice(String officeId,
                               String type,
                               String name);


    List<JlnuXlsxManage> page(@Param("param") XlsxManagePageQuery param,
                              @Param("limit1") int limit1,
                              @Param("limit2") int limit2);


    List<JlnuXlsxManage> getList(@Param("param") XlsxManagePageQuery param);

    List<JlnuXlsxManage> getTemplateList();

    int count(@Param("param") XlsxManagePageQuery param);


    boolean insert(JlnuXlsxManage jlnuXlsxManage);


    boolean update(JlnuXlsxManage jlnuXlsxManage);


    boolean deleteById(Integer id);


    int changeUseById(Integer id, String useState);

}
